Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	19130
Missing cells	120
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.5 MiB
Average record size in memory	192.0 B

Variable types

Categorical	2
DateTime	4
Text	6
Numeric	11
Boolean	1

Alerts

`actual_distance_to_destination` is highly overall correlated with `actual_time` and 4 other fields	High correlation
`actual_time` is highly overall correlated with `actual_distance_to_destination` and 4 other fields	High correlation
`cutoff_factor` is highly overall correlated with `actual_distance_to_destination` and 4 other fields	High correlation
`factor` is highly overall correlated with `segment_factor`	High correlation
`osrm_distance` is highly overall correlated with `actual_distance_to_destination` and 5 other fields	High correlation
`osrm_time` is highly overall correlated with `actual_distance_to_destination` and 5 other fields	High correlation
`route_type` is highly overall correlated with `start_scan_to_end_scan`	High correlation
`segment_actual_time` is highly overall correlated with `segment_osrm_distance` and 1 other fields	High correlation
`segment_factor` is highly overall correlated with `factor`	High correlation
`segment_osrm_distance` is highly overall correlated with `osrm_distance` and 4 other fields	High correlation
`segment_osrm_time` is highly overall correlated with `segment_actual_time` and 1 other fields	High correlation
`start_scan_to_end_scan` is highly overall correlated with `actual_distance_to_destination` and 6 other fields	High correlation
`factor` is highly skewed (γ1 = 20.41257294)	Skewed
`segment_factor` is highly skewed (γ1 = 62.26346765)	Skewed
`segment_actual_time` has 253 (1.3%) zeros	Zeros
`segment_osrm_time` has 311 (1.6%) zeros	Zeros
`segment_osrm_distance` has 207 (1.1%) zeros	Zeros

Reproduction

Analysis started	2024-10-30 11:16:27.767197
Analysis finished	2024-10-30 11:17:13.775755
Duration	46.01 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

data
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	149.6 KiB

training	13822
test	5308

Length

Max length	8
Median length	8
Mean length	6.8901202
Min length	4

Characters and Unicode

Total characters	131808
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	training
2nd row	training
3rd row	training
4th row	training
5th row	training

Common Values

Value	Count	Frequency (%)
training	13822	72.3%
test	5308	27.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
training	13822	72.3%
test	5308	27.7%

Most occurring characters

Value	Count	Frequency (%)
i	27644	21.0%
n	27644	21.0%
t	24438	18.5%
r	13822	10.5%
a	13822	10.5%
g	13822	10.5%
e	5308	4.0%
s	5308	4.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	131808	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	27644	21.0%
n	27644	21.0%
t	24438	18.5%
r	13822	10.5%
a	13822	10.5%
g	13822	10.5%
e	5308	4.0%
s	5308	4.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	131808	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	27644	21.0%
n	27644	21.0%
t	24438	18.5%
r	13822	10.5%
a	13822	10.5%
g	13822	10.5%
e	5308	4.0%
s	5308	4.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	131808	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	27644	21.0%
n	27644	21.0%
t	24438	18.5%
r	13822	10.5%
a	13822	10.5%
g	13822	10.5%
e	5308	4.0%
s	5308	4.0%

trip_creation_time
Date

Distinct	2013
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Memory size	149.6 KiB

Minimum	2018-09-12 00:25:19.499696
Maximum	2018-10-03 23:59:42.701692

Histogram with fixed size bins (bins=50)

route_schedule_uuid
Text

Distinct	962
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Memory size	149.6 KiB

Length

Max length	51
Median length	51
Mean length	51
Min length	51

Characters and Unicode

Total characters	975630
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	0.1%

Sample

1st row	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef
2nd row	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef
3rd row	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef
4th row	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef
5th row	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef

Value	Count	Frequency (%)
thanos::sroute:e2f5faaa-455a-494b-a501-549c3e3081ec	278	1.5%
thanos::sroute:dca6268f-741a-4d1a-b1b0-aab13095a366	231	1.2%
thanos::sroute:0456b740-1dad-4929-bbe0-87d8843f5a10	231	1.2%
thanos::sroute:a4bf93af-8105-4dff-818e-cb79ddd69761	224	1.2%
thanos::sroute:366da0f3-1979-4793-973f-27da63568435	208	1.1%
thanos::sroute:162f9a67-5ebe-4338-8450-1c6d57d2c7b1	185	1.0%
thanos::sroute:fa83fd49-3327-4503-8e80-bf58ed636cc7	184	1.0%
thanos::sroute:67c77992-49e3-4594-9a75-9861ef082a00	183	1.0%
thanos::sroute:be1c03eb-fd2f-4455-a933-5e3d0857e027	179	0.9%
thanos::sroute:15c921f8-8a40-44cc-95ac-59f93d25f780	172	0.9%
Other values (952)	17055	89.2%

Most occurring characters

Value	Count	Frequency (%)
-	76520	7.8%
a	63337	6.5%
:	57390	5.9%
e	55231	5.7%
4	54618	5.6%
9	41209	4.2%
8	39098	4.0%
b	39007	4.0%
5	38356	3.9%
t	38260	3.9%
Other values (15)	472604	48.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	975630	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	76520	7.8%
a	63337	6.5%
:	57390	5.9%
e	55231	5.7%
4	54618	5.6%
9	41209	4.2%
8	39098	4.0%
b	39007	4.0%
5	38356	3.9%
t	38260	3.9%
Other values (15)	472604	48.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	975630	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	76520	7.8%
a	63337	6.5%
:	57390	5.9%
e	55231	5.7%
4	54618	5.6%
9	41209	4.2%
8	39098	4.0%
b	39007	4.0%
5	38356	3.9%
t	38260	3.9%
Other values (15)	472604	48.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	975630	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	76520	7.8%
a	63337	6.5%
:	57390	5.9%
e	55231	5.7%
4	54618	5.6%
9	41209	4.2%
8	39098	4.0%
b	39007	4.0%
5	38356	3.9%
t	38260	3.9%
Other values (15)	472604	48.4%

route_type
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	149.6 KiB

FTL	13117
Carting	6013

Length

Max length	7
Median length	3
Mean length	4.2572922
Min length	3

Characters and Unicode

Total characters	81442
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Carting
2nd row	Carting
3rd row	Carting
4th row	Carting
5th row	Carting

Common Values

Value	Count	Frequency (%)
FTL	13117	68.6%
Carting	6013	31.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ftl	13117	68.6%
carting	6013	31.4%

Most occurring characters

Value	Count	Frequency (%)
F	13117	16.1%
T	13117	16.1%
L	13117	16.1%
C	6013	7.4%
a	6013	7.4%
r	6013	7.4%
t	6013	7.4%
i	6013	7.4%
n	6013	7.4%
g	6013	7.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	81442	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
F	13117	16.1%
T	13117	16.1%
L	13117	16.1%
C	6013	7.4%
a	6013	7.4%
r	6013	7.4%
t	6013	7.4%
i	6013	7.4%
n	6013	7.4%
g	6013	7.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	81442	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
F	13117	16.1%
T	13117	16.1%
L	13117	16.1%
C	6013	7.4%
a	6013	7.4%
r	6013	7.4%
t	6013	7.4%
i	6013	7.4%
n	6013	7.4%
g	6013	7.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	81442	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
F	13117	16.1%
T	13117	16.1%
L	13117	16.1%
C	6013	7.4%
a	6013	7.4%
r	6013	7.4%
t	6013	7.4%
i	6013	7.4%
n	6013	7.4%
g	6013	7.4%

trip_uuid
Text

Distinct	2013
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Memory size	149.6 KiB

Length

Max length	24
Median length	23
Mean length	23.000366
Min length	23

Characters and Unicode

Total characters	439997
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	50 ?
Unique (%)	0.3%

Sample

1st row	trip-153741093647649320
2nd row	trip-153741093647649320
3rd row	trip-153741093647649320
4th row	trip-153741093647649320
5th row	trip-153741093647649320

Value	Count	Frequency (%)
trip-153811219535896559	101	0.5%
trip-153854253003897121	79	0.4%
trip-153828994104597545	78	0.4%
trip-153796781323528185	78	0.4%
trip-153716182991453455	77	0.4%
trip-153841720103113533	77	0.4%
trip-153738046125722247	77	0.4%
trip-153716392193219844	77	0.4%
trip-153733496685379517	77	0.4%
trip-153846880073894675	77	0.4%
Other values (2003)	18332	95.8%

Most occurring characters

Value	Count	Frequency (%)
5	47087	10.7%
1	47006	10.7%
3	45553	10.4%
7	37077	8.4%
8	31983	7.3%
6	28971	6.6%
9	27429	6.2%
2	26494	6.0%
0	26489	6.0%
4	26258	6.0%
Other values (5)	95650	21.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	439997	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	47087	10.7%
1	47006	10.7%
3	45553	10.4%
7	37077	8.4%
8	31983	7.3%
6	28971	6.6%
9	27429	6.2%
2	26494	6.0%
0	26489	6.0%
4	26258	6.0%
Other values (5)	95650	21.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	439997	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	47087	10.7%
1	47006	10.7%
3	45553	10.4%
7	37077	8.4%
8	31983	7.3%
6	28971	6.6%
9	27429	6.2%
2	26494	6.0%
0	26489	6.0%
4	26258	6.0%
Other values (5)	95650	21.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	439997	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	47087	10.7%
1	47006	10.7%
3	45553	10.4%
7	37077	8.4%
8	31983	7.3%
6	28971	6.6%
9	27429	6.2%
2	26494	6.0%
0	26489	6.0%
4	26258	6.0%
Other values (5)	95650	21.7%

source_center
Text

Distinct	1048
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Memory size	149.6 KiB

Length

Max length	12
Median length	12
Mean length	11.999007
Min length	11

Characters and Unicode

Total characters	229541
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	56 ?
Unique (%)	0.3%

Sample

1st row	IND388121AAA
2nd row	IND388121AAA
3rd row	IND388121AAA
4th row	IND388121AAA
5th row	IND388121AAA

Value	Count	Frequency (%)
ind000000acb	3248	17.0%
ind562132aaa	1079	5.6%
ind421302aag	980	5.1%
ind411033aaa	588	3.1%
ind501359aae	488	2.6%
ind560099aab	316	1.7%
ind131028aab	291	1.5%
ind160002aac	280	1.5%
ind712311aaa	260	1.4%
ind600056aab	259	1.4%
Other values (1038)	11341	59.3%

Most occurring characters

Value	Count	Frequency (%)
A	43029	18.7%
0	40768	17.8%
D	19447	8.5%
N	19144	8.3%
I	19131	8.3%
1	16320	7.1%
2	13213	5.8%
3	11097	4.8%
5	8438	3.7%
4	8250	3.6%
Other values (17)	30704	13.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	229541	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	43029	18.7%
0	40768	17.8%
D	19447	8.5%
N	19144	8.3%
I	19131	8.3%
1	16320	7.1%
2	13213	5.8%
3	11097	4.8%
5	8438	3.7%
4	8250	3.6%
Other values (17)	30704	13.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	229541	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	43029	18.7%
0	40768	17.8%
D	19447	8.5%
N	19144	8.3%
I	19131	8.3%
1	16320	7.1%
2	13213	5.8%
3	11097	4.8%
5	8438	3.7%
4	8250	3.6%
Other values (17)	30704	13.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	229541	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	43029	18.7%
0	40768	17.8%
D	19447	8.5%
N	19144	8.3%
I	19131	8.3%
1	16320	7.1%
2	13213	5.8%
3	11097	4.8%
5	8438	3.7%
4	8250	3.6%
Other values (17)	30704	13.4%

source_name
Text

Distinct	1044
Distinct (%)	5.5%
Missing	61
Missing (%)	0.3%
Memory size	149.6 KiB

Length

Max length	44
Median length	41
Mean length	29.900729
Min length	8

Characters and Unicode

Total characters	570177
Distinct characters	67
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	0.3%

Sample

1st row	Anand_VUNagar_DC (Gujarat)
2nd row	Anand_VUNagar_DC (Gujarat)
3rd row	Anand_VUNagar_DC (Gujarat)
4th row	Anand_VUNagar_DC (Gujarat)
5th row	Anand_VUNagar_DC (Gujarat)

Value	Count	Frequency (%)
haryana	3905	9.2%
gurgaon_bilaspur_hb	3248	7.6%
maharashtra	2654	6.2%
karnataka	2479	5.8%
pradesh	2276	5.3%
tamil	1093	2.6%
nadu	1093	2.6%
bangalore_nelmngla_h	1079	2.5%
bhiwandi_mankoli_hb	980	2.3%
telangana	900	2.1%
Other values (1085)	22889	53.7%

Most occurring characters

Value	Count	Frequency (%)
a	93643	16.4%
r	41282	7.2%
_	37291	6.5%
n	30665	5.4%
	23527	4.1%
h	23048	4.0%
l	19642	3.4%
u	19246	3.4%
)	19068	3.3%
(	19068	3.3%
Other values (57)	243697	42.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	570177	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	93643	16.4%
r	41282	7.2%
_	37291	6.5%
n	30665	5.4%
	23527	4.1%
h	23048	4.0%
l	19642	3.4%
u	19246	3.4%
)	19068	3.3%
(	19068	3.3%
Other values (57)	243697	42.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	570177	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	93643	16.4%
r	41282	7.2%
_	37291	6.5%
n	30665	5.4%
	23527	4.1%
h	23048	4.0%
l	19642	3.4%
u	19246	3.4%
)	19068	3.3%
(	19068	3.3%
Other values (57)	243697	42.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	570177	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	93643	16.4%
r	41282	7.2%
_	37291	6.5%
n	30665	5.4%
	23527	4.1%
h	23048	4.0%
l	19642	3.4%
u	19246	3.4%
)	19068	3.3%
(	19068	3.3%
Other values (57)	243697	42.7%

destination_center
Text

Distinct	1036
Distinct (%)	5.4%
Missing	1
Missing (%)	< 0.1%
Memory size	149.6 KiB

Length

Max length	12
Median length	12
Mean length	11.999164
Min length	11

Characters and Unicode

Total characters	229532
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	0.3%

Sample

1st row	IND388620AAB
2nd row	IND388620AAB
3rd row	IND388620AAB
4th row	IND388620AAB
5th row	IND388620AAB

Value	Count	Frequency (%)
ind000000acb	1717	9.0%
ind562132aaa	1111	5.8%
ind421302aag	849	4.4%
ind501359aae	678	3.5%
ind411033aaa	626	3.3%
ind712311aaa	511	2.7%
ind131028aab	461	2.4%
ind160002aac	428	2.2%
ind751002aab	396	2.1%
ind382430aab	382	2.0%
Other values (1026)	11970	62.6%

Most occurring characters

Value	Count	Frequency (%)
A	45454	19.8%
0	33497	14.6%
D	19407	8.5%
I	19129	8.3%
N	19129	8.3%
1	18527	8.1%
2	14945	6.5%
3	12383	5.4%
5	9616	4.2%
4	8093	3.5%
Other values (18)	29352	12.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	229532	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	45454	19.8%
0	33497	14.6%
D	19407	8.5%
I	19129	8.3%
N	19129	8.3%
1	18527	8.1%
2	14945	6.5%
3	12383	5.4%
5	9616	4.2%
4	8093	3.5%
Other values (18)	29352	12.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	229532	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	45454	19.8%
0	33497	14.6%
D	19407	8.5%
I	19129	8.3%
N	19129	8.3%
1	18527	8.1%
2	14945	6.5%
3	12383	5.4%
5	9616	4.2%
4	8093	3.5%
Other values (18)	29352	12.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	229532	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	45454	19.8%
0	33497	14.6%
D	19407	8.5%
I	19129	8.3%
N	19129	8.3%
1	18527	8.1%
2	14945	6.5%
3	12383	5.4%
5	9616	4.2%
4	8093	3.5%
Other values (18)	29352	12.8%

destination_name
Text

Distinct	1030
Distinct (%)	5.4%
Missing	43
Missing (%)	0.2%
Memory size	149.6 KiB

Length

Max length	44
Median length	40
Mean length	30.038194
Min length	13

Characters and Unicode

Total characters	573339
Distinct characters	66
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	0.3%

Sample

1st row	Khambhat_MotvdDPP_D (Gujarat)
2nd row	Khambhat_MotvdDPP_D (Gujarat)
3rd row	Khambhat_MotvdDPP_D (Gujarat)
4th row	Khambhat_MotvdDPP_D (Gujarat)
5th row	Khambhat_MotvdDPP_D (Gujarat)

Value	Count	Frequency (%)
maharashtra	2653	6.1%
pradesh	2650	6.1%
karnataka	2617	6.0%
haryana	2575	5.9%
gurgaon_bilaspur_hb	1717	4.0%
tamil	1136	2.6%
nadu	1136	2.6%
bangalore_nelmngla_h	1111	2.6%
gujarat	1050	2.4%
telangana	1047	2.4%
Other values (1069)	25706	59.2%

Most occurring characters

Value	Count	Frequency (%)
a	93038	16.2%
r	39479	6.9%
_	37344	6.5%
n	30242	5.3%
h	24506	4.3%
	24311	4.2%
)	19087	3.3%
(	19087	3.3%
l	19028	3.3%
e	18601	3.2%
Other values (56)	248616	43.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	573339	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	93038	16.2%
r	39479	6.9%
_	37344	6.5%
n	30242	5.3%
h	24506	4.3%
	24311	4.2%
)	19087	3.3%
(	19087	3.3%
l	19028	3.3%
e	18601	3.2%
Other values (56)	248616	43.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	573339	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	93038	16.2%
r	39479	6.9%
_	37344	6.5%
n	30242	5.3%
h	24506	4.3%
	24311	4.2%
)	19087	3.3%
(	19087	3.3%
l	19028	3.3%
e	18601	3.2%
Other values (56)	248616	43.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	573339	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	93038	16.2%
r	39479	6.9%
_	37344	6.5%
n	30242	5.3%
h	24506	4.3%
	24311	4.2%
)	19087	3.3%
(	19087	3.3%
l	19028	3.3%
e	18601	3.2%
Other values (56)	248616	43.4%

od_start_time
Date

Distinct	3664
Distinct (%)	19.2%
Missing	1
Missing (%)	< 0.1%
Memory size	149.6 KiB

Minimum	2018-09-12 00:39:30.747127
Maximum	2018-10-05 08:35:15.664489

Histogram with fixed size bins (bins=50)

od_end_time
Date

Distinct	3664
Distinct (%)	19.2%
Missing	1
Missing (%)	< 0.1%
Memory size	149.6 KiB

Minimum	2018-09-12 01:32:05.649177
Maximum	2018-10-05 19:10:48.347039

Histogram with fixed size bins (bins=50)

start_scan_to_end_scan
Real number (ℝ)

High correlation

Distinct	830
Distinct (%)	4.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	869.03131

Minimum	25
Maximum	3560
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	25
5-th percentile	68
Q1	149
median	402
Q3	1352
95-th percentile	3001
Maximum	3560
Range	3535
Interquartile range (IQR)	1203

Descriptive statistics

Standard deviation	962.42331
Coefficient of variation (CV)	1.1074668
Kurtosis	0.14039947
Mean	869.03131
Median Absolute Deviation (MAD)	303
Skewness	1.210742
Sum	16623700
Variance	926258.63
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3341	135	0.7%
3178	113	0.6%
86	79	0.4%
3259	79	0.4%
3116	78	0.4%
2998	77	0.4%
3042	77	0.4%
136	77	0.4%
2874	77	0.4%
3001	77	0.4%
Other values (820)	18260	95.5%

Value	Count	Frequency (%)
25	2	< 0.1%
29	5	< 0.1%
30	2	< 0.1%
31	2	< 0.1%
32	7	< 0.1%
33	3	< 0.1%
34	14	0.1%
35	16	0.1%
36	14	0.1%
37	19	0.1%

Value	Count	Frequency (%)
3560	67	0.4%
3341	135	0.7%
3259	79	0.4%
3230	77	0.4%
3178	113	0.6%
3116	78	0.4%
3114	60	0.3%
3113	54	0.3%
3089	49	0.3%
3056	77	0.4%

is_cutoff
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	149.6 KiB

True	15502
False	3627
(Missing)	1

Value	Count	Frequency (%)
True	15502	81.0%
False	3627	19.0%
(Missing)	1	< 0.1%

cutoff_factor
Real number (ℝ)

High correlation

Distinct	367
Distinct (%)	1.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	212.43128

Minimum	9
Maximum	1722
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	9
5-th percentile	9
Q1	22
median	54
Q3	242
95-th percentile	990
Maximum	1722
Range	1713
Interquartile range (IQR)	220

Descriptive statistics

Standard deviation	325.97709
Coefficient of variation (CV)	1.534506
Kurtosis	4.2369428
Mean	212.43128
Median Absolute Deviation (MAD)	37
Skewness	2.1567782
Sum	4063598
Variance	106261.06
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	1893	9.9%
9	1648	8.6%
44	1201	6.3%
18	1120	5.9%
66	801	4.2%
27	763	4.0%
88	602	3.1%
110	495	2.6%
36	469	2.5%
132	428	2.2%
Other values (357)	9709	50.8%

Value	Count	Frequency (%)
9	1648	8.6%
10	59	0.3%
11	59	0.3%
12	46	0.2%
13	46	0.2%
14	69	0.4%
15	78	0.4%
16	81	0.4%
17	61	0.3%
18	1120	5.9%

Value	Count	Frequency (%)
1722	1	< 0.1%
1720	1	< 0.1%
1716	2	< 0.1%
1694	4	< 0.1%
1690	1	< 0.1%
1689	10	0.1%
1688	1	< 0.1%
1687	1	< 0.1%
1672	15	0.1%
1650	15	0.1%

cutoff_timestamp
Date

Distinct	17311
Distinct (%)	90.5%
Missing	1
Missing (%)	< 0.1%
Memory size	149.6 KiB

Minimum	2018-09-12 00:47:25
Maximum	2018-10-05 17:12:00

Histogram with fixed size bins (bins=50)

actual_distance_to_destination
Real number (ℝ)

High correlation

Distinct	19087
Distinct (%)	99.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	213.53329

Minimum	9.0002674
Maximum	1722.0098
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	9.0002674
5-th percentile	9.664379
Q1	23.086633
median	55.362397
Q3	242.66601
95-th percentile	991.36818
Maximum	1722.0098
Range	1713.0095
Interquartile range (IQR)	219.57938

Descriptive statistics

Standard deviation	326.18006
Coefficient of variation (CV)	1.5275373
Kurtosis	4.2328485
Mean	213.53329
Median Absolute Deviation (MAD)	37.656755
Skewness	2.1557363
Sum	4084678.2
Variance	106393.43
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44.26259134	2	< 0.1%
89.22987309	2	< 0.1%
22.69777197	2	< 0.1%
40.57180786	2	< 0.1%
9.574436922	2	< 0.1%
28.9936929	2	< 0.1%
68.65791654	2	< 0.1%
22.98932082	2	< 0.1%
10.00743576	2	< 0.1%
37.24074081	2	< 0.1%
Other values (19077)	19109	99.9%

Value	Count	Frequency (%)
9.000267384	1	< 0.1%
9.000543467	1	< 0.1%
9.000990629	1	< 0.1%
9.001577078	1	< 0.1%
9.001647607	1	< 0.1%
9.002115228	1	< 0.1%
9.002821678	1	< 0.1%
9.00359161	1	< 0.1%
9.004551406	1	< 0.1%
9.004579901	1	< 0.1%

Value	Count	Frequency (%)
1722.009755	1	< 0.1%
1720.765247	1	< 0.1%
1717.23169	1	< 0.1%
1716.603188	1	< 0.1%
1695.72981	1	< 0.1%
1694.671809	1	< 0.1%
1694.370209	1	< 0.1%
1694.277774	1	< 0.1%
1690.302865	1	< 0.1%
1689.847168	1	< 0.1%

actual_time
Real number (ℝ)

High correlation

Distinct	2206
Distinct (%)	11.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	377.0471

Minimum	9
Maximum	3276
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	9
5-th percentile	22
Q1	50
median	119
Q3	438
95-th percentile	1709.6
Maximum	3276
Range	3267
Interquartile range (IQR)	388

Descriptive statistics

Standard deviation	552.51355
Coefficient of variation (CV)	1.4653701
Kurtosis	4.2758388
Mean	377.0471
Median Absolute Deviation (MAD)	87
Skewness	2.1575545
Sum	7212534
Variance	305271.22
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36	203	1.1%
38	196	1.0%
32	195	1.0%
42	192	1.0%
30	175	0.9%
26	167	0.9%
34	166	0.9%
39	154	0.8%
33	151	0.8%
50	143	0.7%
Other values (2196)	17387	90.9%

Value	Count	Frequency (%)
9	13	0.1%
10	17	0.1%
11	36	0.2%
12	72	0.4%
13	50	0.3%
14	90	0.5%
15	92	0.5%
16	80	0.4%
17	85	0.4%
18	138	0.7%

Value	Count	Frequency (%)
3276	1	< 0.1%
3219	1	< 0.1%
3180	1	< 0.1%
3162	1	< 0.1%
3102	1	< 0.1%
3066	1	< 0.1%
3033	1	< 0.1%
3031	1	< 0.1%
3003	1	< 0.1%
2973	1	< 0.1%

osrm_time
Real number (ℝ)

High correlation

Distinct	1277
Distinct (%)	6.7%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	196.26886

Minimum	6
Maximum	1611
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	6
5-th percentile	12
Q1	26
median	59
Q3	220
95-th percentile	888.6
Maximum	1611
Range	1605
Interquartile range (IQR)	194

Descriptive statistics

Standard deviation	292.91788
Coefficient of variation (CV)	1.4924318
Kurtosis	4.6959924
Mean	196.26886
Median Absolute Deviation (MAD)	41
Skewness	2.2236541
Sum	3754427
Variance	85800.883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	330	1.7%
21	330	1.7%
18	314	1.6%
22	311	1.6%
19	309	1.6%
17	282	1.5%
25	264	1.4%
16	259	1.4%
23	255	1.3%
24	255	1.3%
Other values (1267)	16220	84.8%

Value	Count	Frequency (%)
6	24	0.1%
7	102	0.5%
8	133	0.7%
9	157	0.8%
10	168	0.9%
11	239	1.2%
12	226	1.2%
13	228	1.2%
14	221	1.2%
15	167	0.9%

Value	Count	Frequency (%)
1611	1	< 0.1%
1610	1	< 0.1%
1605	1	< 0.1%
1604	1	< 0.1%
1591	2	< 0.1%
1560	1	< 0.1%
1551	1	< 0.1%
1549	2	< 0.1%
1548	4	< 0.1%
1547	2	< 0.1%

osrm_distance
Real number (ℝ)

High correlation

Distinct	18849
Distinct (%)	98.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	260.53128

Minimum	9.1019
Maximum	2191.1664
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	9.1019
5-th percentile	12.58666
Q1	29.0895
median	71.8738
Q3	291.8383
95-th percentile	1212.98
Maximum	2191.1664
Range	2182.0645
Interquartile range (IQR)	262.7488

Descriptive statistics

Standard deviation	400.16469
Coefficient of variation (CV)	1.5359564
Kurtosis	4.6476729
Mean	260.53128
Median Absolute Deviation (MAD)	51.182
Skewness	2.223497
Sum	4983702.9
Variance	160131.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.8935	3	< 0.1%
48.7195	2	< 0.1%
10.7432	2	< 0.1%
175.319	2	< 0.1%
9.6941	2	< 0.1%
22.4752	2	< 0.1%
38.5491	2	< 0.1%
53.4168	2	< 0.1%
30.6035	2	< 0.1%
249.2718	2	< 0.1%
Other values (18839)	19108	99.9%

Value	Count	Frequency (%)
9.1019	1	< 0.1%
9.1306	1	< 0.1%
9.1364	2	< 0.1%
9.1414	1	< 0.1%
9.202	1	< 0.1%
9.2256	1	< 0.1%
9.231	1	< 0.1%
9.2362	1	< 0.1%
9.24	1	< 0.1%
9.2441	1	< 0.1%

Value	Count	Frequency (%)
2191.1664	1	< 0.1%
2189.8849	1	< 0.1%
2185.2996	1	< 0.1%
2185.1355	1	< 0.1%
2152.9283	1	< 0.1%
2152.903	1	< 0.1%
2129.7759	1	< 0.1%
2116.017	1	< 0.1%
2095.6729	1	< 0.1%
2091.6063	1	< 0.1%

factor
Real number (ℝ)

High correlation Skewed

Distinct	9418
Distinct (%)	49.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.0738659

Minimum	0.25
Maximum	77.387097
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	0.25
5-th percentile	1.1666667
Q1	1.5972851
median	1.8528897
Q3	2.2068966
95-th percentile	3.5454545
Maximum	77.387097
Range	77.137097
Interquartile range (IQR)	0.60961148

Descriptive statistics

Standard deviation	1.3699455
Coefficient of variation (CV)	0.66057576
Kurtosis	849.37163
Mean	2.0738659
Median Absolute Deviation (MAD)	0.29294367
Skewness	20.412573
Sum	39670.98
Variance	1.8767508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	337	1.8%
1.5	181	0.9%
1.666666667	116	0.6%
1.75	104	0.5%
3	81	0.4%
1.333333333	76	0.4%
1	76	0.4%
2.25	73	0.4%
1.8	68	0.4%
1.714285714	67	0.4%
Other values (9408)	17950	93.8%

Value	Count	Frequency (%)
0.25	1	< 0.1%
0.2727272727	1	< 0.1%
0.2941176471	1	< 0.1%
0.3440860215	1	< 0.1%
0.3529411765	1	< 0.1%
0.3537414966	1	< 0.1%
0.3880597015	1	< 0.1%
0.4	1	< 0.1%
0.4153846154	1	< 0.1%
0.4342105263	1	< 0.1%

Value	Count	Frequency (%)
77.38709677	1	< 0.1%
66.38888889	1	< 0.1%
45.6875	1	< 0.1%
33.70588235	1	< 0.1%
32.9375	1	< 0.1%
31.2	1	< 0.1%
26.31818182	1	< 0.1%
22.92592593	1	< 0.1%
22.8	1	< 0.1%
21.20408163	1	< 0.1%

segment_actual_time
Real number (ℝ)

High correlation Zeros

Distinct	311
Distinct (%)	1.6%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	35.495426

Minimum	-26
Maximum	2297
Zeros	253
Zeros (%)	1.3%
Negative	4
Negative (%)	< 0.1%
Memory size	149.6 KiB

Quantile statistics

Minimum	-26
5-th percentile	7
Q1	20
median	29
Q3	40
95-th percentile	76
Maximum	2297
Range	2323
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	46.257
Coefficient of variation (CV)	1.303182
Kurtosis	449.4569
Mean	35.495426
Median Absolute Deviation (MAD)	10
Skewness	15.416725
Sum	678992
Variance	2139.7101
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	789	4.1%
26	680	3.6%
30	618	3.2%
28	581	3.0%
36	576	3.0%
32	572	3.0%
27	557	2.9%
23	514	2.7%
12	508	2.7%
25	469	2.5%
Other values (301)	13265	69.3%

Value	Count	Frequency (%)
-26	1	< 0.1%
-21	1	< 0.1%
-5	1	< 0.1%
-1	1	< 0.1%
0	253	1.3%
1	46	0.2%
2	92	0.5%
3	74	0.4%
4	118	0.6%
5	119	0.6%

Value	Count	Frequency (%)
2297	1	< 0.1%
1140	1	< 0.1%
1136	1	< 0.1%
1117	1	< 0.1%
1039	1	< 0.1%
1038	1	< 0.1%
990	1	< 0.1%
942	1	< 0.1%
901	1	< 0.1%
833	1	< 0.1%

segment_osrm_time
Real number (ℝ)

High correlation Zeros

Distinct	126
Distinct (%)	0.7%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	18.404151

Minimum	0
Maximum	469
Zeros	311
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	11
median	17
Q3	22
95-th percentile	37
Maximum	469
Range	469
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	13.515165
Coefficient of variation (CV)	0.73435418
Kurtosis	150.74774
Mean	18.404151
Median Absolute Deviation (MAD)	6
Skewness	7.0713552
Sum	352053
Variance	182.65969
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	1462	7.6%
17	1349	7.1%
18	1198	6.3%
19	909	4.8%
15	829	4.3%
20	791	4.1%
21	673	3.5%
9	656	3.4%
22	652	3.4%
8	643	3.4%
Other values (116)	9967	52.1%

Value	Count	Frequency (%)
0	311	1.6%
1	179	0.9%
2	185	1.0%
3	250	1.3%
4	280	1.5%
5	291	1.5%
6	530	2.8%
7	614	3.2%
8	643	3.4%
9	656	3.4%

Value	Count	Frequency (%)
469	1	< 0.1%
407	1	< 0.1%
383	1	< 0.1%
234	1	< 0.1%
227	1	< 0.1%
221	1	< 0.1%
218	1	< 0.1%
184	1	< 0.1%
180	1	< 0.1%
174	1	< 0.1%

segment_osrm_distance
Real number (ℝ)

High correlation Zeros

Distinct	18290
Distinct (%)	95.6%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	22.605794

Minimum	0
Maximum	635.1196
Zeros	207
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	149.6 KiB

Quantile statistics

Minimum	0
5-th percentile	4.16402
Q1	11.9519
median	23.4432
Q3	27.6426
95-th percentile	42.8949
Maximum	635.1196
Range	635.1196
Interquartile range (IQR)	15.6907

Descriptive statistics

Standard deviation	16.018336
Coefficient of variation (CV)	0.70859428
Kurtosis	221.125
Mean	22.605794
Median Absolute Deviation (MAD)	7.5607
Skewness	8.4675763
Sum	432426.23
Variance	256.5871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	207	1.1%
12.7007	3	< 0.1%
22.9515	3	< 0.1%
27.1815	3	< 0.1%
25.771	3	< 0.1%
25.189	3	< 0.1%
24.4452	3	< 0.1%
24.2347	3	< 0.1%
22.8617	3	< 0.1%
22.4401	3	< 0.1%
Other values (18280)	18895	98.8%

Value	Count	Frequency (%)
0	207	1.1%
0.011	1	< 0.1%
0.0194	1	< 0.1%
0.0198	1	< 0.1%
0.0509	1	< 0.1%
0.0842	1	< 0.1%
0.0931	1	< 0.1%
0.1177	1	< 0.1%
0.138	1	< 0.1%
0.1478	1	< 0.1%

Value	Count	Frequency (%)
635.1196	1	< 0.1%
541.9036	1	< 0.1%
439.6047	1	< 0.1%
320.7535	1	< 0.1%
284.7385	1	< 0.1%
265.0528	1	< 0.1%
249.4472	1	< 0.1%
227.9952	1	< 0.1%
222.5406	1	< 0.1%
216.3338	1	< 0.1%

segment_factor
Real number (ℝ)

High correlation Skewed

Distinct	2146
Distinct (%)	11.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.2227136

Minimum	-1.8571429
Maximum	574.25
Zeros	22
Zeros (%)	0.1%
Negative	314
Negative (%)	1.6%
Memory size	149.6 KiB

Quantile statistics

Minimum	-1.8571429
5-th percentile	0.72727273
Q1	1.35
median	1.6875
Q3	2.25
95-th percentile	4.3333333
Maximum	574.25
Range	576.10714
Interquartile range (IQR)	0.9

Descriptive statistics

Standard deviation	7.4267373
Coefficient of variation (CV)	3.3412929
Kurtosis	4497.771
Mean	2.2227136
Median Absolute Deviation (MAD)	0.41477273
Skewness	62.263468
Sum	42518.289
Variance	55.156427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	815	4.3%
1.5	617	3.2%
1.333333333	324	1.7%
1	319	1.7%
-1	311	1.6%
1.666666667	304	1.6%
3	243	1.3%
1.75	233	1.2%
1.6	185	1.0%
2.5	176	0.9%
Other values (2136)	15602	81.6%

Value	Count	Frequency (%)
-1.857142857	1	< 0.1%
-1	311	1.6%
-0.7	1	< 0.1%
-0.4545454545	1	< 0.1%
0	22	0.1%
0.03076923077	1	< 0.1%
0.05	1	< 0.1%
0.06172839506	1	< 0.1%
0.06896551724	1	< 0.1%
0.07692307692	2	< 0.1%

Value	Count	Frequency (%)
574.25	1	< 0.1%
558.5	1	< 0.1%
493	1	< 0.1%
145	1	< 0.1%
122.2	1	< 0.1%
107	1	< 0.1%
83.66666667	1	< 0.1%
76.33333333	1	< 0.1%
72	2	< 0.1%
62.5	1	< 0.1%

Interactions

Correlations

	actual_distance_to_destination	actual_time	cutoff_factor	data	factor	is_cutoff	osrm_distance	osrm_time	route_type	segment_actual_time	segment_factor	segment_osrm_distance	segment_osrm_time	start_scan_to_end_scan
actual_distance_to_destination	1.000	0.949	0.998	0.098	0.026	0.220	0.990	0.978	0.428	0.277	-0.074	0.494	0.378	0.816
actual_time	0.949	1.000	0.950	0.101	0.235	0.196	0.957	0.954	0.422	0.362	0.049	0.462	0.359	0.821
cutoff_factor	0.998	0.950	1.000	0.098	0.029	0.219	0.990	0.978	0.428	0.273	-0.072	0.486	0.372	0.815
data	0.098	0.101	0.098	1.000	0.000	0.016	0.099	0.098	0.034	0.007	0.000	0.010	0.000	0.233
factor	0.026	0.235	0.029	0.000	1.000	0.073	0.021	-0.021	0.040	0.285	0.572	-0.062	-0.140	0.087
is_cutoff	0.220	0.196	0.219	0.016	0.073	1.000	0.220	0.219	0.144	0.079	0.044	0.000	0.000	0.328
osrm_distance	0.990	0.957	0.990	0.099	0.021	0.220	1.000	0.991	0.425	0.293	-0.081	0.514	0.403	0.819
osrm_time	0.978	0.954	0.978	0.098	-0.021	0.219	0.991	1.000	0.435	0.285	-0.114	0.501	0.417	0.812
route_type	0.428	0.422	0.428	0.034	0.040	0.144	0.425	0.435	1.000	0.020	0.015	0.057	0.079	0.563
segment_actual_time	0.277	0.362	0.273	0.007	0.285	0.079	0.293	0.285	0.020	1.000	0.459	0.678	0.666	0.351
segment_factor	-0.074	0.049	-0.072	0.000	0.572	0.044	-0.081	-0.114	0.015	0.459	1.000	-0.132	-0.227	-0.037
segment_osrm_distance	0.494	0.462	0.486	0.010	-0.062	0.000	0.514	0.501	0.057	0.678	-0.132	1.000	0.923	0.530
segment_osrm_time	0.378	0.359	0.372	0.000	-0.140	0.000	0.403	0.417	0.079	0.666	-0.227	0.923	1.000	0.423
start_scan_to_end_scan	0.816	0.821	0.815	0.233	0.087	0.328	0.819	0.812	0.563	0.351	-0.037	0.530	0.423	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	data	trip_creation_time	route_schedule_uuid	route_type	trip_uuid	source_center	source_name	destination_center	destination_name	od_start_time	od_end_time	start_scan_to_end_scan	is_cutoff	cutoff_factor	cutoff_timestamp	actual_distance_to_destination	actual_time	osrm_time	osrm_distance	factor	segment_actual_time	segment_osrm_time	segment_osrm_distance	segment_factor
0	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388121AAA	Anand_VUNagar_DC (Gujarat)	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	2018-09-20 03:21:32.418600	2018-09-20 04:47:45.236797	86.0	True	9.0	2018-09-20 04:27:55	10.435660	14.0	11.0	11.9653	1.272727	14.0	11.0	11.9653	1.272727
1	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388121AAA	Anand_VUNagar_DC (Gujarat)	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	2018-09-20 03:21:32.418600	2018-09-20 04:47:45.236797	86.0	True	18.0	2018-09-20 04:17:55	18.936842	24.0	20.0	21.7243	1.200000	10.0	9.0	9.7590	1.111111
2	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388121AAA	Anand_VUNagar_DC (Gujarat)	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	2018-09-20 03:21:32.418600	2018-09-20 04:47:45.236797	86.0	True	27.0	2018-09-20 04:01:19.505586	27.637279	40.0	28.0	32.5395	1.428571	16.0	7.0	10.8152	2.285714
3	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388121AAA	Anand_VUNagar_DC (Gujarat)	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	2018-09-20 03:21:32.418600	2018-09-20 04:47:45.236797	86.0	True	36.0	2018-09-20 03:39:57	36.118028	62.0	40.0	45.5620	1.550000	21.0	12.0	13.0224	1.750000
4	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388121AAA	Anand_VUNagar_DC (Gujarat)	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	2018-09-20 03:21:32.418600	2018-09-20 04:47:45.236797	86.0	False	39.0	2018-09-20 03:33:55	39.386040	68.0	44.0	54.2181	1.545455	6.0	5.0	3.9153	1.200000
5	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	IND388320AAA	Anand_Vaghasi_IP (Gujarat)	2018-09-20 04:47:45.236797	2018-09-20 06:36:55.627764	109.0	True	9.0	2018-09-20 06:15:58	10.403038	15.0	11.0	12.1171	1.363636	15.0	11.0	12.1171	1.363636
6	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	IND388320AAA	Anand_Vaghasi_IP (Gujarat)	2018-09-20 04:47:45.236797	2018-09-20 06:36:55.627764	109.0	True	18.0	2018-09-20 05:47:29	18.045481	44.0	17.0	21.2890	2.588235	28.0	6.0	9.1719	4.666667
7	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	IND388320AAA	Anand_Vaghasi_IP (Gujarat)	2018-09-20 04:47:45.236797	2018-09-20 06:36:55.627764	109.0	True	27.0	2018-09-20 05:25:58	28.061896	65.0	29.0	35.8252	2.241379	21.0	11.0	14.5362	1.909091
8	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	IND388320AAA	Anand_Vaghasi_IP (Gujarat)	2018-09-20 04:47:45.236797	2018-09-20 06:36:55.627764	109.0	True	36.0	2018-09-20 05:15:56	38.939167	76.0	39.0	47.1900	1.948718	10.0	10.0	11.3648	1.000000
9	training	2018-09-20 02:35:36.476840	thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef	Carting	trip-153741093647649320	IND388620AAB	Khambhat_MotvdDPP_D (Gujarat)	IND388320AAA	Anand_Vaghasi_IP (Gujarat)	2018-09-20 04:47:45.236797	2018-09-20 06:36:55.627764	109.0	False	43.0	2018-09-20 04:49:20	43.595802	102.0	45.0	53.2334	2.266667	26.0	6.0	6.0434	4.333333

	data	trip_creation_time	route_schedule_uuid	route_type	trip_uuid	source_center	source_name	destination_center	destination_name	od_start_time	od_end_time	start_scan_to_end_scan	is_cutoff	cutoff_factor	cutoff_timestamp	actual_distance_to_destination	actual_time	osrm_time	osrm_distance	factor	segment_actual_time	segment_osrm_time	segment_osrm_distance	segment_factor
19120	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND842003AAB	Jabalpur_Adhartal_IP (Madhya Pradesh)	IND487001AAB	Narsinghpur_KndliDPP_D (Madhya Pradesh)	2018-10-03 21:30:56.518460	2018-10-04 01:35:20.805767	244.0	True	22.0	2018-10-04 00:56:14	23.318250	30.0	25.0	26.9380	1.200000	30.0	25.0	26.9380	1.200000
19121	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND842003AAB	Jabalpur_Adhartal_IP (Madhya Pradesh)	IND487001AAB	Narsinghpur_KndliDPP_D (Madhya Pradesh)	2018-10-03 21:30:56.518460	2018-10-04 01:35:20.805767	244.0	True	44.0	2018-10-04 00:20:17	44.973964	65.0	47.0	50.5832	1.382979	35.0	21.0	23.6452	1.666667
19122	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND842003AAB	Jabalpur_Adhartal_IP (Madhya Pradesh)	IND487001AAB	Narsinghpur_KndliDPP_D (Madhya Pradesh)	2018-10-03 21:30:56.518460	2018-10-04 01:35:20.805767	244.0	True	66.0	2018-10-03 22:30:17	73.369213	175.0	74.0	86.5853	2.364865	110.0	27.0	36.0021	4.074074
19123	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND842003AAB	Jabalpur_Adhartal_IP (Madhya Pradesh)	IND487001AAB	Narsinghpur_KndliDPP_D (Madhya Pradesh)	2018-10-03 21:30:56.518460	2018-10-04 01:35:20.805767	244.0	False	84.0	2018-10-03 22:12:13	84.479723	194.0	80.0	94.6273	2.425000	18.0	8.0	12.4032	2.250000
19124	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND487001AAB	Narsinghpur_KndliDPP_D (Madhya Pradesh)	IND487551AAA	Gadarwara_MPward_D (Madhya Pradesh)	2018-10-04 01:57:29.964868	2018-10-04 03:16:19.550538	78.0	True	22.0	2018-10-04 02:38:17	23.142929	38.0	27.0	28.7071	1.407407	38.0	27.0	28.7071	1.407407
19125	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND487001AAB	Narsinghpur_KndliDPP_D (Madhya Pradesh)	IND487551AAA	Gadarwara_MPward_D (Madhya Pradesh)	2018-10-04 01:57:29.964868	2018-10-04 03:16:19.550538	78.0	False	41.0	2018-10-04 02:12:15	41.713301	64.0	48.0	52.3647	1.333333	26.0	20.0	23.6576	1.300000
19126	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND487551AAA	Gadarwara_MPward_D (Madhya Pradesh)	IND464668AAA	Bareli_SourvDPP_D (Madhya Pradesh)	2018-10-04 03:16:19.550538	2018-10-04 06:25:37.976768	189.0	True	22.0	2018-10-04 05:22:22	22.408595	48.0	34.0	31.5766	1.411765	48.0	34.0	31.5766	1.411765
19127	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND487551AAA	Gadarwara_MPward_D (Madhya Pradesh)	IND464668AAA	Bareli_SourvDPP_D (Madhya Pradesh)	2018-10-04 03:16:19.550538	2018-10-04 06:25:37.976768	189.0	True	44.0	2018-10-04 04:02:19	44.195324	128.0	67.0	80.9943	1.910448	80.0	39.0	41.4102	2.051282
19128	test	2018-10-03 21:30:56.518460	thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780	FTL	trip-153860225651817784	IND487551AAA	Gadarwara_MPward_D (Madhya Pradesh)	IND464668AAA	Bareli_SourvDPP_D (Madhya Pradesh)	2018-10-04 03:16:19.550538	2018-10-04 06:25:37.976768	189.0	False	57.0	2018-10-04 03:42:14	57.341503	148.0	62.0	75.0091	2.387097	20.0	18.0	18.2876	1.111111
19129	training	2018-09-21 06:43:44.036195	thanos::sroute:9f229200-bc86-4418-90ae-653498358781	Carting	trip-153751222403597152	IND141003AAB	Ludhiana	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories